create procedure [dbo].[BAEUpdateOrderTransactionsByOrderNumber] @orderNum decimal(18,2),
     @amount money as
UPDATE    Trans
    SET        AMOUNT = -(@amount)
    WHERE    TRANS_NUMBER IN (
            SELECT    trans.TRANS_NUMBER
            FROM        Trans trans INNER JOIN
                    Orders orders ON trans.BATCH_NUM = orders.BATCH_NUM INNER JOIN
                    Order_Lines olines ON olines.ORDER_NUMBER = orders.ORDER_NUMBER
            WHERE    orders.ORDER_NUMBER = @orderNum AND
                    orders.PREPAID_INVOICE_REFERENCE_NUM = trans.INVOICE_REFERENCE_NUM AND
                    trans.LINE_NUMBER = 1 AND
                    trans.TRANSACTION_TYPE = 'PP')  AND
        LINE_NUMBER = 1;

    UPDATE    Trans
    SET        AMOUNT = @amount,
            INVOICE_CREDITS = @amount
    WHERE    TRANS_NUMBER IN (
            SELECT    trans.TRANS_NUMBER
            FROM        Trans trans INNER JOIN
                    Orders orders ON trans.BATCH_NUM = orders.BATCH_NUM INNER JOIN
                    Order_Lines olines ON olines.ORDER_NUMBER = orders.ORDER_NUMBER
            WHERE    orders.ORDER_NUMBER = @orderNum AND
                    orders.PREPAID_INVOICE_REFERENCE_NUM = trans.INVOICE_REFERENCE_NUM AND
                    trans.LINE_NUMBER = 2 AND
                    trans.TRANSACTION_TYPE = 'PAY') AND
        LINE_NUMBER = 2;

GO